DROP TABLE IF EXISTS jms_dm.dm_big_customer_waybill_status_dt ;
create external table jms_dm.dm_big_customer_waybill_status_dt
(
  waybill_no string COMMENT '运单号',
  scan_type string COMMENT '扫描类型',
  scan_time date COMMENT '扫描时间',
  scan_site string COMMENT '扫描网点',
  scan_user string COMMENT '扫描人',
  this_scan_type string COMMENT '当前扫描类型',
  this_scan_time string COMMENT '当前扫描时间',
  this_scan_site date COMMENT '当前扫描网点',
  this_scan_user string COMMENT '当前扫描人',
  difficult string COMMENT '问题件扫描原因',
  other string COMMENT '留仓原因'
)
comment'客服部大客户运单状态明细分析取数'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_big_customer_waybill_status_dt'
TBLPROPERTIES (
    'discover.partitions' = 'false',  -- 禁止 hive 自动发现分区
    'parquet.column.index.access' = 'true');

